package com.cmnit.analysis.dao

import com.cmnit.analysis.common.{TDao, TSql}
import org.apache.log4j.Logger
import org.apache.spark.sql.DataFrame

class GbVerticalSectionDicDao extends TSql with TDao {
  private val logger: Logger = Logger.getLogger(this.getClass)

  /**
   * 加工结果数据
   */
  def GbVerticalSectionDicData(): DataFrame = {
    sparkSQL(
      "SELECT " +
        "id, " +
        "name, " +
        "type, " +
        "length, " +
        "startlat, " +
        "startlng, " +
        "startstakenum, " +
        "endstakenum, " +
        "endlat, " +
        "endlng, " +
        "tollroads, " +
        "provincetype, " +
        "endtime, " +
        "operation, " +
        "recordgentime, " +
        "responsecode, " +
        "responseinfo, " +
        "receivetime, " +
        "protime, " +
        "batchfilename, " +
        "status, " +
        "roadid, " +
        "direction, " +
        "begintime, " +
        "verticalsectiontype " +
        "FROM " +
        "DIM.DIM_TBL_GbVerticalSectionDic ")
  }
}
